File Restore with Bulk Data Loader
When restoring projects with a very large time-phased data, you can run the Restore process with the Bulk Data Loader method to run the process much more quickly.
Restore Using Bulk Data Loader
When using the Restore process with the Bulk Data Loader method, Cobra uses the normal Restore process in restoring all data except the time-phased data and the Bulk Data Loader method in restoring time-phased data for TPHASE, COSTELEM, and BASEHIST tables on an Oracle database.
To use the Bulk Data Loader method, you must define UseBulkDataLoader=1. To run the Bulk Data Loader method automatically, you must define BulkDataLoaderAutoRun=1.
When you restore a single project through the Cobra application, you must select the Use bulk data loader checkbox in the Select Files to Restore dialog box. If this checkbox is cleared, Cobra will proceed with the normal Restore process.
When you restore multiple projects through the Cobra application, Cobra checks the UseBulkDataLoader setting to determine whether the Bulk Data Loader method will be used or not when running the Restore process.
Using Bulk Data Loader with BulkDataLoaderAutoRun=1
When BulkDataLoaderAutoRun=1, you do not need to perform additional steps.
Using Bulk Data Loader with BulkDataLoaderAutoRun=0
When BulkDataLoaderAutoRun=0, you must perform additional steps on the generated files to load time-phased data completely.
- Make sure the Bulk Data Loader statement is correct in the generated CostelemLoad.bat, TphaseLoad.bat, and BasehistLoad.bat files.
- Replace uid/pwd@instance with the appropriate user ID, password, and Oracle instance ID so that Bulk Data Loader can load time-phased data.
- Cobra does not put the uid/password credentials in the batch files.
- Enclose the password with \" if you are using special characters. For example, a password of p@ssword should be \"p@ssword\".
- Delete angled brackets (<>) around the string if present.
- The batch file assumes that the Oracle SQL loader executable file (sqlldr.exe) path is found in the Windows path. If not, include the full path in front of Bulk Data Loader reference.
- Related Topics:
- Generated Output Files
Cobra generates comma-separated values (CSV) files, control files, and batch files for the TPHASE, COSTELEM, and BASEHIST tables when running the Restore process with Bulk Data Loader. - Recommendations
There are several recommendations that you may consider before using Restore with Bulk Data Loader.